﻿CREATE TABLE [mem].[kv]
(
	[Key] varchar(255) COLLATE Latin1_General_100_BIN2 not null, 
	[KeyId] bigint identity not null,
	[Version] int not null,
	[Expiry] datetime2 not null,
	[Harden] bit not null default 1
	
   constraint [mem_kv_PK]
		primary key nonclustered hash ([Key]) with (BUCKET_COUNT = 131072)
) 
with (MEMORY_OPTIMIZED = ON, DURABILITY=SCHEMA_AND_DATA)